dhaval tamboli

Just for others to make it work.. use one space before \t.
e.g.

StringTokenizer st = new StringTokenizer(myString, " \t");

Hi Guys,

I am not able to find out workaround of this issue.
Here is the case.
I am having hibernate xml mapping files for my tables.
I can add one-to-many relation in mapping and it works fine, but getting problem when child table has another one to many relationship.
e.g.
Segment is parent table and it has country as a child table. so i join country as
<list name="country" inverse="true" lazy="false" cascade="all" fetch="join"> <key> <column name="SEGMENT_ID" sql-type="CHAR(26)" index="COUNTRY_SEGMENT_IDX" /> </key> <list-index column="elementIndex"/> <one-to-many class="com.bhn.service.segment.Country" /> </list>

Everything is defined and its working fine here.
but now country table has a child table of states (with one to many relationship) so at com.bhn.service.segment.Country table i have list of states
and in country.hbm.xml file , I define it as

<list name="states" inverse="false" lazy="false" cascade="all" fetch="join"> <key> <column name="COUNTRY_ID" sql-type="CHAR(26)" index="SEGMENT_STATE_PROVINCE_IDX"/> </key> <list-index column="elementIndex"/> <one-to-many class="com.bhn.service.segment.State" /> </list>

but I guess till country_id gets inserted, it tries to save state and throws error that Null value found in Not null column.
Not sure how to implement this.. after this I have cities table also as child of state with one to many relationship, so i m not sure how to implement this.

Thanks in advance

Thanks for your reply Fatih.
I can see class using that query. and yes I am using SQL Developer.
I feel Oracle JVM is giving me trouble. I'm not sure if we are allowed to change java.home for oracle or if we can include few jar files in oracle jvm classpath.
Actually it's not my class who is giving me problem. I am trying to decrypt database data which calls different provider jar files to create session with them.
to create a session with provider, I need to add few files into classpath and need to change java security policy files.

e.g. in normal jdk. I need to add jar files at jdk/jre/lib/ext dir and change local_policy.jar and us_export_policy.jar files at jdk/jre/lib/security.
but I am not sure how can I do that for oracle jvm.

Hi,

I am trying to run one stored java procedure from oracle client. For that I must need to access few java classes from different jar files.
so I loaded my java classes and loaded jar files also. but classes in jar files loaded with some wiered name in oracle.
e.g. if class is com.temp.create.checkProvider, then in oracle it's loaded as '/1000ed42_checkProvider'.. I don't know why that.

so, I thought to include those jar files in jvm classpath. but as it's using database server java.home. java.class.path is null even if on database server i included those jar files in classpath.
now, without setting classpath for oracle client, I am not able to go ahead with my java procedure.

I tried to set classpath using my java program using systemProperty but I figured it won't be applied as classpath is applied at jvm startup. so I am not sure, what to do now.

Pleases let me know if anybody knows anything..

Thanks

you are right, that file was on client machine. I added it on database server.

Thanks

Disregrad dbuser in giving grants.
I used ORIGDV85B only

Hi Guys,

May be I am making stupid fundamental mistake, but I am not able to figure out, what!!

Let me tel you briefly, What I am trying to do.

I loaded few jar files to oracle using loadjava and created one java class, to call one class(which is in jar file) and get the result.
now, that class(jar one) calls one file on disk (which is hardcoded) and depending on that it performs operation.

Firstly, I got this error (which is expected).

java.security.AccessControlException: the Permission (java.io.FilePermission /opt/temp.ini read) has not been granted to ORIGDV85B. The PL/SQL to grant this is dbms_java.grant_permission( 'ORIGDV85B', 'SYS:java.io.FilePermission', '/opt/temp.ini', 'read' )

After that I gave grant using

exec dbms_java.grant_permission( 'dbuser', 'SYS:java.io.FilePermission', '/opt/temp.ini', 'read' );

so now, it should work, but now I am getting this error

java.io.FileNotFoundException: No such file or directory

Actually, It's not able to find file, but I am 100% sure I have provided right file name and path.
So I am not sure why this error!!

By the way, my oracle is at /opt/oracle11

I am not sure, what I am doing regarding giving grant is correct or not, but I verified grant by select * from USER_JAVA_POLICY where grantee_name = 'dbuser';
And I can see it's enabled..

Let me know, if i am wrong somewhere

Thanks

yeah, i need to keep jstl1.0
servlet:2.3 and jsp:1.2

How would I know, which is compatible version of jstl? i'm using JRun4 as server

Hi,

It seems very stupid and annoying error I am getting.
I have one jsp page which already uses jstl.

now if i add any new jstl variable or new condition. whole layout of jsp page gets mess.
I'm using jstl1.0.

I'm not sure what might be the problem and what may cause it. e.g. adding <c:set var="temp" value="true"/> messes my jsp page.
did anybody face this kind of problem?

Hi Ankit,

I know I am doing right, but I am not able to get anything in jsp. However I tried to see in action class if I am loading it right or if there is any other problem but there I can see each elements in order by get methods.

Here in JSP page, I tried to see its size but even that also not showing anything.

I tried <s:property value="oList.size()" />

but still nothing. I dont know what to do next
please help me

Thanks
Dhaval

Hi,

I am using struts2.

My design is like I have Araaylist which has another arraylist in it.

i.e.
In My action class I do have

private List<GenericModel> previewList;

and GenericModel contains

private int Question_ID; private String Question_Name; private String Question_Type; private List<OptionModel> oList = new ArrayList<OptionModel>();

and OptionModel contains

private int Option_ID; private String Option;

I have eneterd all information correctly but I am not able to show them on JSP in way I want.

my JSP Page contains

<s:iterator value="previewList" var="list"> <s:iterator value="#list.oList" var="opt"> <s:property value="#opt.Option" /> </s:iterator> <tr> <s:property value="Question_Name" /> </tr> <tr> <s:property value="Question_Type" /> </tr> </s:iterator>

I want to show all information contained in previewList, I can see Question_Name and other but I am not sure how to access information from OptionModel list.
Above code is not working (just the oList part) I am not able to see its contents.

please give your thoughts to solve my problem

Thanks,
Dhaval

Hi,

I am using struts2.
Actually I am stuck at one point. I do have one form and there are 3 submit calls in same form. In last submit call, I am inserting record in database but to know which one is final submit, I need to pass some flag saying that this is final submit.

so, I though to set parameter in jsp page (when last submit pressed) and trying to get parameter in action class but it says null. so, I am confused to do what next.

Here, is my code and also if there is any other method doing so then please let me know.


<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ taglib prefix="s" uri="/struts-tags"%> <%@ page language="java" %> <% String type = request.getParameter("Question_Type"); int typeValue=0; if(type!=null) typeValue=Integer.parseInt(type); String option = request.getParameter("Option_Number"); int options=0; if(option!=null) options = Integer.parseInt(option); %> <html> <head> <title>Feedback Collection System | By Dhaval Tamboli</title> </head> <script language="JavaScript" type="text/javascript"> function selfSubmit(){ var cboTestObj = me.Question_Type.selectedIndex; me.submit(); } function optionSubmit(){ var cboTestObj = me.Option_Number.selectedIndex; me.submit(); } function onSubmit(){ request.setParameter("flag","true"); me.submit(); } </script> <body> <s:if test="#session.logged-in != true"> <jsp:forward page="/index.jsp" /> </s:if> <h2>Create Questionnaire</h2> <s:actionerror /> <s:form name="me" action="temp" method="post"> <s:param name="dd" value="true"/> <s:textfield name="Question_Name" key="label.Question" size="20" /> <s:select name="Question_Type" key="label.Questiontype" size="20" list="#{'1':'Single Select Option', '2':'Multiple Select Option', '3':'Comment Box', '4':'Rating Scale', '5':'Yes/No'}" headerKey="-1" size="1" headerValue="--- Please Select ---" onchange="javascript: selfSubmit();" /> <br/> <%if(typeValue==1 || typeValue==2) {%> <s:select name="Option_Number" key="label.Option" size="20" list="#{'1':'1', '2':'2', '3':'3', '4':'4', '5':'5'}" headerKey="-1" size="1" headerValue="--- Please Select ---" onchange="javascript: optionSubmit();"/> <br/> <%if(options==1) {%> <s:textfield name="Option_1" key="label.value" size="20"/> <% } else if(options==2) {%> <s:textfield name="Option_1" key="label.value" size="20"/> <s:textfield name="Option_2" key="label.value" size="20"/> <% } else if(options==3) {%> <s:textfield name="Option_1" key="label.value" size="20"/> <s:textfield name="Option_2" key="label.value" size="20"/> <s:textfield name="Option_3" key="label.value" size="20"/> <%} else if(options==4) {%> <s:textfield name="Option_1" key="label.value" size="20"/> <s:textfield name="Option_2" key="label.value" size="20"/> <s:textfield name="Option_3" key="label.value" size="20"/> <s:textfield name="Option_4" key="label.value" size="20"/> <% }else if(options==5) {%> <s:textfield name="Option_1" key="label.value" size="20"/> <s:textfield name="Option_2" key="label.value" size="20"/> <s:textfield name="Option_3" key="label.value" size="20"/> <s:textfield name="Option_4" key="label.value" size="20"/> <s:textfield name="Option_5" key="label.value" size="20"/> <%} %> <%} %> <input type="button" value="<s:text name='label.create'/>" onClick="javascript: onSubmit();"/> </s:form> </body> </html>

Thanks
Dhaval

Hi,

I got your point but I dont know how to see generated html code and also I am confused regarding fetching combobox's value in javascript.

Thanks

HI, I think my problem is total different.

I am posting whole jsp page as such it will extend once I can find combobox's selected value.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ taglib prefix="s" uri="/struts-tags"%> <html> <head> <title>Feedback Collection System | By Dhaval Tamboli</title> </head> <script language="JavaScript" type="text/javascript"> function selfSubmit(){ System.out.println("Test 1: "); document.frmIndex.action=""; var cboTestObj = document.getElementById("Question_Type"); System.out.println("Hope: "+cboTestObj); document.frmIndex.submit(); } </script> <body> <s:if test="#session.logged-in != true"> <jsp:forward page="/index.jsp" /> </s:if> <h2>Create Questionnaire</h2> <s:actionerror /> <s:form action="addQuestionnaire" method="post"> <s:textfield name="Question_ID" key="label.Questionid" size="20"/> <s:textfield name="Question_Name" key="label.Question" size="20" /> <s:combobox name="Question_Type" key="label.Questiontype" size="20" list="{'Single Select Option','Multiple Select Option','Comment Box','Rating Scale', 'Yes/No'}" headerKey="-1" headerValue="--- Please Select ---" onchange="javascript: selfSubmit();" /> <s:submit method="create" key="label.create" align="right" /> </s:form> </body> </html>