[dnaik]

Hello

I am trying to create a hibernate mapping for a table. I got the error ‘Internal error occurred during : “Generating Artifacts”‘.

I looked up a few other posts on this board who had the same problem and they asked to make sure that the project was using ojdbc14.jar and also the connecttion url had “jdbc:oracle:thin:…” in it.

I have confirmed that my envrionment has both the above set correctly. Also when I had installed Eclipse 4.1.1, it was a clean install. Yet I am getting this error.

Any ideas what else I can look at ?

Thanks.

[Haris Peco]

dnaik ,

Send us log error (Windows – Show view – Other – PDE runtime – Show error log).Please remove log (delete log icon in log error view), start hibernate mapping again and send contents of error log view after this

Thanks

[dnaik]

support-snpe,

Here is the log. I saw the message invalid username/password in this log, I corrected the same in my hibernate.cfg.xml. But I still get this error.

!ENTRY org.eclipse.core.runtime 4 2 2006-04-05 12:56:21.134
!MESSAGE An internal error occurred during: “Generating Artifacts”.
!STACK 0
org.hibernate.exception.GenericJDBCException: Getting database metadata
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getMetaData(JDBCMetaDataDialect.java:61)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:70)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:395)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:65)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration$1.readDatabaseSchema(MEJDBCMetaDataConfiguration.java:102)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:87)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfiguration.java:129)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$5.execute(GenerateArtifactsJob.java:405)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:68)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob.java:400)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:266)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:497)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:23)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getConnection(JDBCMetaDataDialect.java:294)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getMetaData(JDBCMetaDataDialect.java:58)
… 12 more

Thanks,
Deepa

[Haris Peco]

Deepa,

error

ORA-01017: invalid username/password; logon denied

mean that you have wrong username/password – double check username/password in hibernate.cfg.xml and check that hibernate pick correct hibernate.cfg.xml (it have to be in root in source directory or / in classpath)

You can send us hibernate.cfg.xml , too

Do you have one or more hibernate projects ?

Best

[dnaik]

support-snpe,

Like I mentioned in my earlier post, I saw the invalid username/password message, corrected it in the cfg file and yet it gives me the error.

Yes I do have more than one hibernate projects.

Here is my hibernate.cfg.xml file :

xml version=’1.0′ encoding=’UTF-8′?>
<!DOCTYPE hibernate-configuration PUBLIC
“-//Hibernate/Hibernate Configuration DTD 3.0//EN”
“http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd”&gt;

<!– Generated by MyEclipse Hibernate Tools. –>
<hibernate-configuration>
<session-factory>
<property name=”connection.username”>itapps</property>
<property name=”connection.url”>jdbc:oracle:thin:@ushqua011.hostname.com:1521:PMINTDEV</property>
<property name=”dialect”>org.hibernate.dialect.Oracle9Dialect</property>
<property name=”myeclipse.connection.profile”>PMINTDEV</property>
<property name=”connection.password”>welcome</property>
<property name=”connection.driver_class”>oracle.jdbc.driver.OracleDriver</property>
</session-factory>
</hibernate-configuration>

Thanks,
Deepa

[Haris Peco]

Deepa,

I beleive that you set correct username/password (you can open connection profile PMINTDEV in Db Explorer ?)
It it is ok, then hibernate grab another hibernate.cfg.xml (maybe from another project – I ask you for more project for this) – when you start ‘Hibernate mapping action’ and get first wizard page you have field ‘java src folder’ – you choose source from some hibernate project – hibernate pick hibernate.cfg.xml from this project in root (source directory of project)

Best

[dnaik]

support-snpe,

When I start the Hibernate mapping action, I confirmed that the Java src folder and the Java package I selected, are for the Hibernate project that I am working on and not for the other Hibernate projects I have. So I assume the hibernate.cfg.xml file (which is in the src directory of project) should be used.

Yet I see the error that username/password is invalid.

Thanks,
Deepa

[Haris Peco]

Deepa,

It is hard what is error, but you can login with bad login or password

check if you have more source directories (more hibernate.cfg.xml) in project – check hibernate.properties, too (some version hibernate use hibernate.properties first

Q: Do you can log with db explorer and connection profile PMINTDEV ?

Best

[dnaik]

Yes I can log in via db explorer to PMINTDEV using the username/password.

Where can I find the hibernate.properties file ?

Thanks,
Deepa

[Haris Peco]

Where can I find the hibernate.properties file ?

I don’t know – I suppose that you have some file which hibernate grab before your hibernate.cfg.xml

you can use eclipse search (Menu search -> file) and search if you have more files hibernate.cfg.xml (or hibernate.properties) in project

[Brian Fernandes]

Deepa,

During reverse engineering, the user name and password from your DB profile are used, not the username and password from your hibernate.cfg.xml file or hibernate.properties file. So changing the values in the hibernate.cfg.xml file wil make no difference.

Can you make sure that the username and password that you’re using in your Profile to connect to the DB are the same username and password you are specifying in your configuration file and it does have all the priviledges necessary for reverse engineering?

Best,
Brian.

[dnaik]

Hi Support-snpe and Brian

I deleted the PMINTDEV db profile and recreated it with the correct username/password. The problem was that when I created the DB profile the first time, I had used a different username/password and that was being used.

I no longer get the error and the correct mapping files got generated. Thanks a lot for all your help and support in figuring out this issue.

Deepa

[Author]

Posts