vijaya sharma

Greenhorn
+ Follow
since Dec 30, 2003
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by vijaya sharma

This error is received on the primary database.

while the services for the standby and the primary databases are working perfect on the standby database.The ports at which they listen are also configured properly.There does not seem to be any firewall issue because i am able to ping and tnsping to the primary and standby to and fro. also the remote logging and file transfer works on both the systems.

Thanks

Vijay
17 years ago
lsnrctl services standby_database

This results in an error which says that:

TNS-01189:The listener could not authenticate the user.


Note: The listener and the services are properly configured for the standby and the primary database, which are configured on CentOS and Oracle 10g.

Any idea what could be the problem.

Thanks,
Vijay
17 years ago
We just migrated from hibernate2 to hibernate3, and everything seems to work just fine except this error which i get only when i try to load some object. Also I don't think it's significant in this context but we are using spring along with hibernate. Now the error seems to come only when I try to insert, or update.

Full stack trace is here:

org.hibernate.LazyInitializationException: could not initialize proxy - the owning Session was closed
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:56)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:98)
at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:158)
at some.hibernate.UserAccount$$EnhancerByCGLIB$$80039dd0_2.getUserAccountName(<generated>
at com.some.dao.someUserPrefReadWriteHibernate.InsertMBDefault(someUserPrefReadWriteHibernate.java:160)
at com.some.dao.someCSRDaoTest.testPAsomeCSRDao(someCSRDaoTest.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:164)
at junit.framework.TestCase.runBare(TestCase.java:130)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:120)
at junit.framework.TestSuite.runTest(TestSuite.java:228)
at junit.framework.TestSuite.run(TestSuite.java:223)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)


ANY VIEW ON THIS WOULD BE GREATLY APPRECIATED,

Thanks,
Vijay.
Q)What Error/Exception/unexpected behaviour do you see when you use Spring?

A)When i run This code, i excpect to get the name of the hibernate mapped class to be returned(which representes a table), like wise when i am using query on muliple table and multiple columns, I expect the object[] class to return me each object that i refer to in the query.The one below was an example quering one table.


Q)And how do you run this without Spring? getHibernateTemplate() is a Spring method, so you must be running different code when you don't use Spring, yes?
A)Sorry Jeff, i assumed that you would ignore getHibernateTemplate Method since it's spring's Method. I meant the code to get the class name from the query works well, when used with only Hibernate and not spring(Just to point out that specific peice of code is not what i think should be a problem).

Thank you for responding to my queries.
Vijay.
Thanks Jeff,Anuja and michael. Identity as the document says works.
I am using hibernate 2.0 with spring 1.2.4. How can i find the dependencies required for the hibernate2.

Thanks
Though the table has some thousand rows but i have a criteria to limit it to one , works well in other application.

here is the error entry, any help will be appreciated.Thanks


NOTE This exception you get generally when you are accessing a table returning large number of rows)

java.lang.NullPointerException
at org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)
at org.hibernate.persister.entity.AbstractEntityPersister.createProxy(AbstractEntityPersister.java:3121)
at org.hibernate.event.def.DefaultLoadEventListener.createProxyIfNecessary(DefaultLoadEventListener.java:232)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:173)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:869)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:838)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2150)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:117)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1607)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:121)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:169)
at com.boats.dao.sampleDaoHibernate.selectsampleStatus(sampleDaoHibernate.java:28)
at com.boats.dao.sampleDaoManualTest.testselectsampleStatus(sampleDaoManualTest.java:27)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
I am using spring/hibernate

The following code is working perfect when i DO NOT use spring



any comments?

[Edited to include code tags - Paul Sturrock]
[ January 12, 2006: Message edited by: Paul Sturrock ]
Hi,
Thanks for the reply
I am using spring-xml file where i have configured the dilect property

<bean id="boatsSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="boatsDataSource"/>
</property>

<property name="mappingDirectoryLocations">
<list>
<value></value>
</list>
</property>

<property name="hibernateProperties">
<props>
(See This Line)
<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">false</prop>
</props>
</property>
</bean>


As you suggested that i should let hibernate decide, I tried using the native but it didn't work as well.

Do you think there could be somethis else to it.

Thanks in advance.
I am using hibernate 3.0 and spring 1.2.4

When i try to instantiate the Class object using the test(which uses JUnit) with out performing any inserts( just trying to extract the column value)

I get the following Error:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SomeNameObjectSessionFactory' defined in class path resource [some-manualtest-test.xml]: Initialization of bean failed; nested exception is org.hibernate.MappingException: could not instantiate id generator

org.hibernate.MappingException: could not instantiate id generator

I wonder why it should not be able to generate the id,The id generator code extracted from the HBM file is as follows:

<id name="Id" type="long" column="some_id">
<generator class="sequence">
<param name="sequence">some_id_seq</param>
</generator>
</id>

I would be greatly thankful if someone could tell me if there is something wrong, with respect to maybe incompatible versions of hibernate and spring or am i missing something.

Thanks,
Vijay
Thanx mark,
This is a good reason,i will be gald if i get more views and responses further.
Again thanx to all you great people out there,
VS
20 years ago
Hi all,
can someone tell me the good business reasons to upgrade from oracle8i to oracle9i,
Yes,like all of you i also know that it has performance and management advantage over 8i but i am not able to come out with good business reasons to convinvce my boss as every businessman looks at it as a revenue increase point of view,please help me with some good business reasons to upgrade and also any suggestions and your simplest viwes are acceptable.please also write about any technical stuff you think is right.
Thanx a lot in advance,
VS.
20 years ago
Hi all,
I have installed the jmeter and done the recording,which recorded the steps that i want jmeter to repeate and load test my database,i used the user parameter option to set multiple user with different values but there is also a alternative to it by specifying the file name conatining the list of values instead of entering the names individually in the user parameter option.
all works fine but user parameter option doens't work with the filename,it works fine when i individually specify each user
I am having great problem as i want to test database with 1000 of different values.
please Help,
Thanx to you all in advance,
VS
20 years ago
Yes ,I am using the exp of 8i and imp of 9i.
I would like again specify the correct error which i get after i do the complete import from oracle8i into the 9i database.This is an application error,which comes while accessing the database via website having websphere in middle layer which takes the values stores as java timestamp and stores it back in database as date.
Error 500: Cannot fetch result set because SQL type of column 3 in meta data is 93 but actual type is 91.
This error is resolved when i alter the date datatype to timestamp.
All i want is not change the datatype after i do the import.
I will be extreamly thankful if you can help.
Also it would be great if someone can help me know the good business reasons for upgrading from oracle8i to oracle9i.i know all the technical advantages in terms of improved performance and easier management.it would be nice if someone can give some business reasons for upgrading since every businessman sees it from the point of increased revenues
Thanx to all you great people out there,
VS.
20 years ago
Hi,
I am given the task of migrating oracle8i database to oracle9i. everything is going fine except one thing.
At the application level,java programming is used which converts the date data into timestamp type and then stores the data in database as date as oracle8i does not have timestamp datatype.
Now when i import the data from oracle8i database into oracle9i database withaout any changes,it given me the metadata error that it requires type 31 whereas it is getting type 32.this error is resolved though,when i change the datatype from date to timestamp in oracle9i.
Please can you help me with this problem,i dont want to change the datatype in oracle9i from date to timestamp as that requires lot of work when importing data from oracle8i to oracle9i as it is a daily job of importing,any structural changes at that time looks very risky and unneccessary.
Thanx a million in advance.
VS
20 years ago