Attachment: screenshot-1.jpg [ 10560 ]

Attachment: screenshot-2.jpg [ 10561 ]

Attachment: hibernate.cfg.xml [ 10562 ]

Attachment: dbscript.sql [ 10563 ]

description: I?m plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

A last detail: I have 2 user UDFcreated on my firebird engine that appears visible on my new database

=>

I?m plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

description: I?m plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

=>

I am plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

I got the stacktrace using MyEclipse PDE Error Log:

java.lang.NumberFormatException: For input string: "c"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl$DbAttachInfo.<init>(AbstractJavaGDSImpl.java:2514)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:369)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:89)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:470)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:119)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

description: I am plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

I got the stacktrace using MyEclipse PDE Error Log:

java.lang.NumberFormatException: For input string: "c"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl$DbAttachInfo.<init>(AbstractJavaGDSImpl.java:2514)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:369)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:89)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:470)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:119)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

=>

Please, close this Issue.

There is not a problem.

After got the stack trace I found the code at sourceforge and discovered I mistook in URL formation.

I am plaining use Firebird with Hibernate in a new java project but I had problems when I tried map my database tables using two main Hibernate related Eclipse plugins to do this. These plugins works when I use other database like Oracle or MySQL.

I got the stacktrace using MyEclipse PDE Error Log:

java.lang.NumberFormatException: For input string: "c"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl$DbAttachInfo.<init>(AbstractJavaGDSImpl.java:2514)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:369)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:89)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:470)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:119)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)

The folowing steps should reproduce the error:
1 - Create a Firebird SQL Dialect 3 database
2 - Create a simple table according to this script: CREATE TABLE DUAL ( DUMMY CHAR(1));
3 - Using Eclipse 3.3 install one of these plugins: Hibernate Tools (http://www.tools.hibernate.org) or Hibernate Synchronizer (http://sourceforge.net/projects/hibernatesynch/) the same error occurs using any of that plugins
4 - Create a new project in Eclipse
5 - With Hibernate Tools:
a) File / New / Other... / Hibernate / Hibernate Configuration File (cfg.xml) / Next / Next
b) Any name for Session factory name, Firebird for Database dialect, org.firebirdsql.jdbc.FBDriver for Driver class, url pointing to our database
c) Check the "Create a console configuration" box / Next / give a name for your console configuration / Finish
d) Window / Show View / Other... / Hibernate / Hibernate Configurations
e) In the Hibernate Configurations view click on Database
e) The error occurs: "Error while fetching children Reason: java.lang.NumberFormatException: For input string: "c""

6 - With Hibernate Synchronizer:
a) File / New / Other... / Hibernate / Hibernate Configuration File
b) Create a Hibernate config file using org.firebirdsql.jdbc.FBDriver driver and Interbase Dialect
c) Open hibernate.cfg.xml and change dialect property value to org.hibernate.dialect.FirebirdDialect
d) File / New / Other... / Hibernate / Hibernate Mapping File
d) After inform the driver, user and password, click on Refresh
e) The error occurs: "For input string: "C""

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]